MYSQL CLIENT ERROR : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'acciaio-goal-size-choice"%')) AND (3 IN (SELECT DISTINCT(orderChannel) FROM sale' at line 1 // SELECT id,rank,parentId,name_en,name_fr,name_de,name_nl,name_hu,name_it,name_pl,name_es,name_pt,name_ro,name_cz,name_sk,status,tags,dateInsert,dateUpdate,author,lastAuthor,authorId,lastAuthorId,serial,data,urlKey_en,urlKey_fr,urlKey_de,urlKey_nl,urlKey_hu,urlKey_it,urlKey_pl,urlKey_es,urlKey_pt,urlKey_ro,urlKey_cz,urlKey_sk,link,isToRegister,metaTitle_en,metaTitle_fr,metaTitle_de,metaTitle_nl,metaTitle_hu,metaTitle_it,metaTitle_pl,metaTitle_es,metaTitle_pt,metaTitle_ro,metaTitle_cz,metaTitle_sk,metaDesc_en,metaDesc_fr,metaDesc_de,metaDesc_nl,metaDesc_hu,metaDesc_it,metaDesc_pl,metaDesc_es,metaDesc_pt,metaDesc_ro,metaDesc_cz,metaDesc_sk,(SELECT image FROM productImageGalleries WHERE ref=saleProducts.refImages) AS image,description_en,description_fr,description_de,description_nl,description_hu,description_it,description_pl,description_es,description_pt,description_ro,description_cz,description_sk,shortDescription_en,shortDescription_fr,shortDescription_de,shortDescription_nl,shortDescription_hu,shortDescription_it,shortDescription_pl,shortDescription_es,shortDescription_pt,shortDescription_ro,shortDescription_cz,shortDescription_sk,categoryId,(saleProducts.ref) AS sku,purchasePrice,price,discount,productType,weight,stock,canBeOrderedOutOfStock,shippingDelayOutOfStock,shippingDelayInStock,ean,ref,refImages,refData,refTechnicalSheet,refInstructionSheet,(SELECT id FROM saleProductDatas WHERE ref=saleProducts.refData) AS saleProductData,(SELECT ROUND(SUM(rating)/COUNT(*),1) FROM customerReviews WHERE ref=saleProducts.refData) AS averageRating,(SELECT COUNT(*) FROM customerReviews WHERE ref=saleProducts.refData) AS numberRatings,(SELECT id FROM technicalSheets WHERE ref=saleProducts.refTechnicalSheet) AS technicalSheet,(SELECT id FROM instructionSheets WHERE ref=saleProducts.refInstructionSheet) AS instructionSheet,bestSeller,saleCategory,composition,optionProducts,substitutionProducts,brand,(SELECT secondaryImages FROM productImageGalleries WHERE ref=saleProducts.refImages) AS otherImages,(SELECT videos FROM productImageGalleries WHERE ref=saleProducts.refImages) AS videos,(SELECT videoFiles FROM productImageGalleries WHERE ref=saleProducts.refImages) AS videoFiles,grossWeight,netWeight,width,length,height,color,shippingTime,(SELECT GROUP_CONCAT(DISTINCT(SELECT name_en FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) AS orderChannels,(SELECT GROUP_CONCAT(DISTINCT(SELECT image FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) AS orderChannelsLogos,stockEU,stockUK,sport,size,type,normalPrice,discountPrice,netPrice,publicPrice,hasOptions,features FROM saleProducts WHERE (ref IN (SELECT ref FROM saleProducts WHERE refData IN (SELECT ref FROM saleProductDatas WHERE data LIKE '%"urlKey2_it": "calcio%20d'acciaio-goal-size-choice"%')) AND (3 IN (SELECT DISTINCT(orderChannel) FROM saleProductOffers WHERE saleProduct=saleProducts.id))) AND (status=1) ORDER BY ref ASC LIMIT 50 OFFSET 0
Warning: Cannot modify header information - headers already sent by (output started at /application/specific/clients/mysqlConnection.php:116) in /application/core/classes/app.php on line 679

Warning: Cannot modify header information - headers already sent by (output started at /application/specific/clients/mysqlConnection.php:116) in /application/core/classes/app.php on line 687